Drill-down between Composite Controls

This topic describes the drill-down between Composite Controls of Business Measures of type Graph on a dashboard (XForm Designer).

On a dashboard (XForm Designer), you can drive from one view to another while making one of the content panes as the Source and other content as the Target.

While creating a dashboard, you can select any number of composite controls content of type Business Measures and define drill-down between them. Map the output parameter of the source view composite control (Business Measure) to the input parameter of the target view composite control (Business Measure or KPI).

The following example explains the drill-down concept.

Example:
You have created two Business Measures of type Graph called 'No. of Orders by Product' and 'Units in Stock for Product'. The query for the same is as follows:

1. No. of Orders by Product: Select Count(OrderID) No._Of_Orders, ProductName Group by ProductName
   
2. Units in Stock for Product: Select Avg(UnitsInStock) Units_In_Stock, ProductName Where ProductName = :ProductName Group by ProductName.
   
   The composite controls for the respective Business Measures are created. The objective is to create a drill-down from 'No. of Orders by Product' to 'Units in Stock for Product'. Drag both the composite controls in a dashboard (XForms) designer and configure drill-down between them. Map the output parameter of Source 'ProductName' to Input parameter 'ProductName' for Target view. You can save and assign the created XForm (using composite controls) to a user/role to view it as a dashboard.
   Preview the XForm. In the XForm preview, click on a data point in the view generated for source view (Business Measure). For example, click the bar if the view type for the content is 'Bar chart'. The target view (Business Measure) appears in the pane already defined for it.
   Note:
   
3. If you have created drill-down for composite controls of multiple business measures, then you can view the target views (of multiple business measures) in the panes already defined for them.
   
4. For the drill-down between composite controls of composite Business Measures for example, consider Composite Business Measure, CBM1(constituting Business Measures, BM1 and BM2) as source, and Composite Business Measure, CBM2 (constituting Business Measure, BM3 and BM4) as target to work:
   
   1. Map the output parameter of the source of BM1 of CBM1 to:
      1. the input parameter of BM3 of CBM2 and
      2. the input parameter of BM4 of CBM2
         
   2. Map the output parameter of the source of BM2 of CBM1 to:
      1. the input parameter of BM3 of CBM2 and
      2. the input parameter of BM4 of CBM2

In the XForm preview, open the 'No. of Orders by Product' view. Click the No. of orders bar to populate the 'Units in Stock for Product' view that appears in the pane already defined for it.